USE [vudu]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[ConsultarProfesorRol]
@ciProfesor varchar(30)
AS
BEGIN
	SET NOCOUNT ON;
	
	SELECT id_rol
	  FROM ROL
	 WHERE fk_id_profesor = @ciProfesor;
END;

SET ANSI_NULLS ON